package com.boc.ewr.business.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.boc.ewr.business.entity.AcctDtlClassA1;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description: A1类账户明细
 * @Author: jeecg-boot
 * @Date:   2023-05-26
 * @Version: V1.0
 */
public interface AcctDtlClassA1Mapper extends BaseMapper<AcctDtlClassA1> {

    //根据
    @Select("select * from (select bus.* from BUS_ACCT_INFO bus INNER JOIN HGRSK_LGL_RPST hlr ON bus.LGL_RPST_NM = hlr.LGL_RPST_NM OR bus.LGL_RPST_ID = hlr.LGL_RPST_ID) acct LEFT JOIN CAC ca ON acct.ACC_NO = ca.ACC_NO")
    List<AcctDtlClassA1> creatInfo();
}
